# coding: utf-8
import json
import api as api
from DBAction import DBAction


def importdata():
    '''从文件获取信息，并存到数据库的成员表中'''
    db = DBAction('pocket48')
    insert_user_sql = "INSERT INTO member(memberid, name, name_pinyin, roomid, weibo_uid) " \
                      "VALUES(%s, %s, %s, %s, %s)"
    mj = json.load(open('member.json', encoding='utf8'))
    # print(mj)
    for key in mj:
        print(mj[key])
        if 'member_id' in mj[key]:
            id = mj[key]['member_id']
            name = mj[key]['chinese_name']
            rid = mj[key]['room_id']
        else:
            id = mj[key]['id']
            name = mj[key]['name'].replace('SNH48-', '')
            rid = mj[key]['roomId']
        db.data_operate(insert_user_sql, (id, name, mj[key]['pinyin'], rid, mj[key]['weibo_uid']))


def get_team(icon):
    if 'snh48_h2.png' in icon:
        return 'HII'
    elif 'idft_logo_2.png' in icon:
        return 'IDFT'
    elif 'gnz_z_log2.png' in icon:
        return 'Z'
    elif 'gnz48_n3.png' in icon:
        return 'NIII'
    elif 'gnz48_g.png' in icon:
        return 'G'
    elif '15992025288054qD21JfZgU.png' in icon:
        return 'BEJ48'
    elif '1591182591234C5oe14AgSR' in icon:
        return 'THE9'
    elif '16213099186970lapqp5g8z' in icon:
        return 'CKG48'
    elif 'snh48_s2.png' in icon:
        return 'SII'
    elif 'snh48_x.png' in icon:
        return 'X'
    elif 'snh48_n2.png' in icon:
        return 'NII'
    elif 'snh48_team_yubeisheng.png' in icon:
        return 'ybs'
    else:
        return ''


def import_json():
    '''
    从关注列表获取房间信息，需要持续更新的有房间title和头像
    TODO 添加向roomused存储数据的逻辑
    '''
    url = 'https://pocketapi.48.cn/im/api/v1/conversation/page'
    params = {"targetType": "0"}
    mj = api.post(url, params)

    db = DBAction('pocket48')
    insert_user_sql = "INSERT INTO member(memberid, name, team, roomid) " \
                      "VALUES(%s, %s, %s, %s)"
    insert_room_sql = "INSERT INTO room(roomid, memberid, roomavatar, roomname) " \
                      "VALUES(%s, %s, %s, %s)"
    get_user_sql = f"select count(1) from member where memberid=%s"
    get_room_sql = f"select count(1) from room where roomid=%s"

    mj = mj["content"]["conversations"]
    for user in mj:
        print(user)
        id = user['ownerId']
        if len(user['ownerName'].split('-')) == 1:
            continue

        tuan = user['ownerName'].split('-')[0]
        name = user['ownerName'].split('-')[1]
        rid = user['targetId']
        Avatar = user['targetAvatar']
        roomtitle = user['targetName']
        team = get_team(user['icon'][0])

        if team == 'ybs':
            if tuan == 'SNH48':
                team = 'SNH预备生'
            elif tuan == 'GNZ48':
                team = 'GNZ预备生'

        result = db.data_inquiry_all(get_user_sql, id)
        if result[0][0] == 0:
            db.data_operate(insert_user_sql, (id, name, team, rid))
        else:
            db.data_operate(f"update member set team=%s where memberid=%s", (team, id))

        result = db.data_inquiry_all(get_room_sql, rid)
        if result[0][0] == 0:
            db.data_operate(insert_room_sql, (rid, id, Avatar, roomtitle))


def update_team():
    """从fiddler里得到聊天列表，来更新team和roomid，来新人了可以操作一次"""
    response = json.loads(r'{"status":200,"success":true,"message":"OK","content":{"conversations":[{"targetName":"偶像运动会🪁","targetAvatar":"/20200720/1595215977714fU8LxYNzz7.jpg","targetType":0,"targetId":"67236601","msg":"哇","msgTime":1621776729201,"icon":[],"ownerId":"63","ownerName":"袋王","totalMsgCount":0},{"targetName":"一只林Luna哦🍹","targetAvatar":"/20200809/159697851444808T713alhh.jpg","targetType":0,"targetId":"67246064","msg":"直个播哦","msgTime":1621776724879,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"5562","ownerName":"SNH48-林楠","totalMsgCount":1953},{"targetName":"小安的被窝开空调了","targetAvatar":"/20210413/16183024474580xwi6jigpm.jpg","targetType":0,"targetId":"67370588","msg":"谢谢巴雷特的coco🥤\r谢谢nomorefish的星巴克🥤","msgTime":1621776703505,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"607521","ownerName":"GNZ48-罗可嘉","totalMsgCount":108665},{"targetName":"我和你一样👩‍👦","targetAvatar":"/20210521/1621573107277gqsim61k7b.jpg","targetType":0,"targetId":"180129550","msg":"[直播消息]","msgTime":1621776692529,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"7984906291","ownerName":"BEJ48-王丹妮","totalMsgCount":53051},{"targetName":"考驾照（公演不在）","targetAvatar":"/20200807/1596803363973ZVyr32Ph9h.jpg","targetType":0,"targetId":"67236607","msg":"不然手停不下来","msgTime":1621776682619,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"25","ownerName":"SNH48-万丽娜","totalMsgCount":10079},{"targetName":"心碎男女孩收容所💔","targetAvatar":"/20210408/1617891444075paw4xx4h0s.jpg","targetType":0,"targetId":"67265540","msg":"原相机yyds","msgTime":1621776656776,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"707371","ownerName":"GNZ48-徐楚雯","totalMsgCount":31668},{"targetName":"【傷感.小辣妹👄","targetAvatar":"/20210113/16104682721164Hk8am3p8X.jpg","targetType":0,"targetId":"67313745","msg":"你们都没有发现我的挂耳染","msgTime":1621776629336,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"63571","ownerName":"SNH48-田姝丽","totalMsgCount":11699},{"targetName":"POP闲的日常💽","targetAvatar":"/20200818/1597762445749I4O8j8xX2Y.jpg","targetType":0,"targetId":"67303252","msg":"谢谢这位画手55555好喜欢","msgTime":1621776603070,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"407110","ownerName":"SNH48-刘闲","totalMsgCount":39697},{"targetName":"冰糖童话🎈","targetAvatar":"/20210203/1612359395477kfSW1OJrQg.jpg","targetType":0,"targetId":"261507061","msg":"[直播消息]","msgTime":1621776585251,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285691","ownerName":"BEJ48-唐晨葳","totalMsgCount":14978},{"targetName":"给你一个机会你会不会","targetAvatar":"/20210518/16213163647023rip726s0l.jpg","targetType":0,"targetId":"67256391","msg":"嗨～晚上好🌇","msgTime":1621776584140,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614773","ownerName":"CKG48-赵泽慧","totalMsgCount":376},{"targetName":"张总的麻辣笋丝制作厂","targetAvatar":"/20210421/1618934928418ikye6d68tv.jpg","targetType":0,"targetId":"261489779","msg":"[直播消息]","msgTime":1621776549816,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285698","ownerName":"BEJ48-张宸祎","totalMsgCount":11353},{"targetName":"星星口袋","targetAvatar":"/20210323/1616487417481ya830xx3p3.jpg","targetType":0,"targetId":"67380550","msg":"打道回府","msgTime":1621776521391,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"407127","ownerName":"SNH48-张怀瑾","totalMsgCount":33599},{"targetName":"神话森林 #","targetAvatar":"/20210402/16173787146759kwa9xdyi4.jpg","targetType":0,"targetId":"67199580","msg":"[直播消息]","msgTime":1621776355111,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"327602","ownerName":"SNH48-刘胜男","totalMsgCount":12650},{"targetName":"便利贴的便利店","targetAvatar":"/20201106/1604651357410uz7F9xxDQC.jpg","targetType":0,"targetId":"248604670","msg":"躺下去的时候抵在耳麦上了","msgTime":1621776354306,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"42402886","ownerName":"SNH48-卞楚娴","totalMsgCount":10992},{"targetName":"包治百病！！！","targetAvatar":"/20210210/16129310586456k3lxlmjl8.jpg","targetType":0,"targetId":"67390990","msg":"现在没事了","msgTime":1621776339648,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"607515","ownerName":"GNZ48-黄楚茵","totalMsgCount":35604},{"targetName":"双叶幼儿园向日葵班","targetAvatar":"/20200428/15880684251384U7KjMCu5E.jpg","targetType":0,"targetId":"67236638","msg":"发好啦","msgTime":1621776265474,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"327560","ownerName":"GNZ48-张琼予","totalMsgCount":26906},{"targetName":"陈你呀的废话日记本","targetAvatar":"/20210415/1618427711560oulb5787a7.jpg","targetType":0,"targetId":"224665866","msg":"旁边明明有母婴室🚼","msgTime":1621776234648,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"39911921","ownerName":"CKG48-陈妮亚","totalMsgCount":40711},{"targetName":"出道半周年快乐🥳","targetAvatar":"/20210504/1620103928135cvzojm9o5m.jpg","targetType":0,"targetId":"261502235","msg":"我又开始迷糊了","msgTime":1621776208020,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285669","ownerName":"BEJ48-陈蓁蓁","totalMsgCount":31908},{"targetName":"范璐元·Alter","targetAvatar":"/20210421/1618947468092t6vpjh83rl.jpg","targetType":0,"targetId":"261490803","msg":"[图片消息]","msgTime":1621776077745,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285672","ownerName":"BEJ48-范璐元","totalMsgCount":18077},{"targetName":"✨恭✨喜✨發✨財✨","targetAvatar":"/20200919/1600518150766mBqAZWXXpH.jpg","targetType":0,"targetId":"67390943","msg":"对的","msgTime":1621776066195,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6742","ownerName":"SNH48-王晓佳","totalMsgCount":34672},{"targetName":"格兰芬多公共休息室","targetAvatar":"/20210511/16206669092571m1hwyk51o.jpg","targetType":0,"targetId":"377983628","msg":"好想打我自己 什么时候可以准时一次","msgTime":1621776002558,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526100","ownerName":"SNH48-张诗芸","totalMsgCount":1472},{"targetName":"海拉鲁老流氓🧝🏼","targetAvatar":"/20201225/1608838895230ti4L2X4c6d.jpg","targetType":0,"targetId":"67207817","msg":"我揍你","msgTime":1621775944945,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"327601","ownerName":"SNH48-陈倩楠","totalMsgCount":17402},{"targetName":"聊天室A","targetAvatar":"/mediasource/room/1493277152571M4Maby92gt.jpg","targetType":0,"targetId":"67313743","msg":"晚安吧大家","msgTime":1621775932950,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"63558","ownerName":"SNH48-洪珮雲","totalMsgCount":4847},{"targetName":"🐽燕","targetAvatar":"/20210409/1617958611046va8nxx6ha2.jpg","targetType":0,"targetId":"67303271","msg":"[直播消息]","msgTime":1621775919648,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"459997","ownerName":"IDFT-朱燕","totalMsgCount":26560},{"targetName":"动物世界","targetAvatar":"/20200707/1594120498995hKsn9wpI2g.jpg","targetType":0,"targetId":"67246081","msg":"放心啦 我还是可以自主生活的捏","msgTime":1621775893397,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"327598","ownerName":"SNH48-张笑盈","totalMsgCount":20145},{"targetName":"🌻","targetAvatar":"/20210318/1616034813793u6rm2kdpgx.jpg","targetType":0,"targetId":"67207851","msg":"偷狗","msgTime":1621775831892,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6431","ownerName":"SNH48-陈琳","totalMsgCount":42591},{"targetName":"冉金鑫和你的家🏠","targetAvatar":"/20201007/1602080124836K79zuh4B3B.jpg","targetType":0,"targetId":"67333162","msg":"我回去眯一会儿在直播哦","msgTime":1621775799072,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"614734","ownerName":"SNH48-冉蔚","totalMsgCount":38771},{"targetName":"真的不是小鱼干","targetAvatar":"/20210424/1619238195688s9brc1c2sw.jpg","targetType":0,"targetId":"370409322","msg":"[大哭]","msgTime":1621775690804,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"42402897","ownerName":"GNZ48-吕曼菲","totalMsgCount":3500},{"targetName":"🤟🏻小霏星球🌍","targetAvatar":"/20210413/1618248655911m9ixdy5v00.jpg","targetType":0,"targetId":"67352339","msg":"给你们握握","msgTime":1621775683046,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"607591","ownerName":"GNZ48-吴羽霏","totalMsgCount":45562},{"targetName":"羽的魔法学院！","targetAvatar":"/20210423/16191654934695s6nipxqx9.jpg","targetType":0,"targetId":"67265451","msg":"因为燃","msgTime":1621775663967,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"63567","ownerName":"SNH48-潘瑛琪","totalMsgCount":31690},{"targetName":"校长面包房","targetAvatar":"/20210417/1618668397929dmfkzyn92y.jpg","targetType":0,"targetId":"181396030","msg":"[直播消息]","msgTime":1621775621421,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"8957984819","ownerName":"GNZ48-张书瑀","totalMsgCount":15231},{"targetName":"chua雨航局","targetAvatar":"/20210508/1620418915570ttafyv7vw2.jpg","targetType":0,"targetId":"381012316","msg":"我喜欢泰罗，有没有泰罗！","msgTime":1621775590737,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"52494482","ownerName":"GNZ48-江雨航","totalMsgCount":3722},{"targetName":"Jaylin_","targetAvatar":"/20210521/16215760635171abvp3v9mm.jpg","targetType":0,"targetId":"157010991","msg":"[直播消息]","msgTime":1621775540824,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"5384437777","ownerName":"SNH48-张睿婕","totalMsgCount":24388},{"targetName":"“小王总的办公室”","targetAvatar":"/20190813/1565630672207fn36aRzf6n.jpg","targetType":0,"targetId":"67189834","msg":"[直播消息]","msgTime":1621775462396,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"530388","ownerName":"SNH48-王菲妍","totalMsgCount":30348},{"targetName":"我好像是你阳大哥😎","targetAvatar":"/20210204/16123803658557lnzdo6uDA.jpg","targetType":0,"targetId":"67352300","msg":"我点的就是专门卖三文鱼生鲜类的","msgTime":1621775427023,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"63576","ownerName":"GNZ48-阳青颖","totalMsgCount":20611},{"targetName":"⛈","targetAvatar":"/20210422/161909240012408k13g4u7t.jpg","targetType":0,"targetId":"67293873","msg":"剪了半天 不知道要怎么剪❌","msgTime":1621775327959,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417324","ownerName":"GNZ48-王芊诺","totalMsgCount":32895},{"targetName":"保护我方局棒🧸","targetAvatar":"/20201111/1605090352227KhFZO68i5r.jpg","targetType":0,"targetId":"67265514","msg":"[直播消息]","msgTime":1621775323949,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"530452","ownerName":"GNZ48-朱怡欣","totalMsgCount":46645},{"targetName":"💜🥚推🌟","targetAvatar":"/20210521/162158599646522re8hw00o.jpg","targetType":0,"targetId":"67256412","msg":"然后明天又要回学校了🏫😞","msgTime":1621775322751,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"867888","ownerName":"CKG48-曹露丹","totalMsgCount":15935},{"targetName":"小海苔😭","targetAvatar":"/20210508/1620459509243lb0qax7jpo.jpg","targetType":0,"targetId":"387989946","msg":"公演","msgTime":1621775222112,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"52494487","ownerName":"GNZ48-王琰","totalMsgCount":960},{"targetName":"小瑞突然出现","targetAvatar":"/20210327/1616777945425m0009tookv.jpg","targetType":0,"targetId":"67390893","msg":"其实我小时候也吃不来咸的","msgTime":1621775170067,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417320","ownerName":"GNZ48-龙亦瑞","totalMsgCount":26507},{"targetName":"包间","targetAvatar":"/20200825/159828808330905d437M8U0.jpg","targetType":0,"targetId":"67362289","msg":"哈哈哈哈","msgTime":1621775169774,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"63559","ownerName":"SNH48-胡晓慧","totalMsgCount":22693},{"targetName":"没有灵魂的泥娃娃本人","targetAvatar":"/20201116/1605520750585r96S75BR5J.jpg","targetType":0,"targetId":"67275447","msg":"我吃完饭啦（＾ν＾）","msgTime":1621775158693,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"399669","ownerName":"SNH48-袁一琦","totalMsgCount":39008},{"targetName":"婉拒巧克力与奶茶❗️","targetAvatar":"/20210506/1620273251678ria039pdyk.jpg","targetType":0,"targetId":"143189214","msg":"x","msgTime":1621775125114,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"4528799751","ownerName":"BEJ48-张智杰","totalMsgCount":38601},{"targetName":"小问号你是不是没朋友","targetAvatar":"/20210407/1617787214960e04480c854.jpg","targetType":0,"targetId":"67352360","msg":"[直播消息]","msgTime":1621775063726,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"722784","ownerName":"GNZ48-谢菲菲","totalMsgCount":25846},{"targetName":"EL DORADO","targetAvatar":"/20210323/1616460535967pe9ev6kqvc.jpg","targetType":0,"targetId":"67207831","msg":"[直播消息]","msgTime":1621775015490,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6743","ownerName":"SNH48-谢天依","totalMsgCount":7326},{"targetName":"甜豆来袭！！！","targetAvatar":"/20190415/155533197855669V8c363ND.jpg","targetType":0,"targetId":"67217582","msg":"[直播消息]","msgTime":1621774986651,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417326","ownerName":"GNZ48-王偲越","totalMsgCount":12742},{"targetName":"BlingBling","targetAvatar":"/20210508/1620485797166yd38nj1w7y.jpg","targetType":0,"targetId":"67370540","msg":"[直播消息]","msgTime":1621774937015,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417311","ownerName":"GNZ48-陈桂君","totalMsgCount":36462},{"targetName":"红桃皇后的舞台","targetAvatar":"/20200607/1591502471242UK58f6Zwgh.jpeg","targetType":0,"targetId":"67199596","msg":"下课啦","msgTime":1621774917829,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"6739","ownerName":"SNH48-孙歆文","totalMsgCount":10755},{"targetName":"❤️💓💗💖💕","targetAvatar":"/20191018/1571411800955BZy5s5lyy0.jpg","targetType":0,"targetId":"67236674","msg":"晚安啦！","msgTime":1621774906617,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614742","ownerName":"CKG48-左欣","totalMsgCount":10201},{"targetName":"吃醋偶像","targetAvatar":"/20210511/16207162167684nm315o8bo.jpg","targetType":0,"targetId":"155329896","msg":"没有比柯南唐红的恋歌最烂的剧场版了[大哭]","msgTime":1621774796387,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"6827278358","ownerName":"GNZ48-马昕玥","totalMsgCount":49102},{"targetName":"兔牙的别墅🏩🌴","targetAvatar":"/20201019/1603086872744ATp35Vla6x.jpg","targetType":0,"targetId":"67207862","msg":"mc把墨镜摘了","msgTime":1621774706147,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"458335","ownerName":"SNH48-李慧","totalMsgCount":41738},{"targetName":"你掉了一只兔子ᕱ⑅ᕱ","targetAvatar":"/20200815/1597495797723jZhukm0I3o.jpg","targetType":0,"targetId":"67313807","msg":"来啦","msgTime":1621774593294,"icon":[],"ownerId":"35","ownerName":"莫寒","totalMsgCount":18589},{"targetName":"🧸✨美丽阿玥✨🎀","targetAvatar":"/20210418/161871534033959j99f4krh.jpg","targetType":0,"targetId":"248610452","msg":"[直播消息]","msgTime":1621774511451,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"42402792","ownerName":"SNH48-邓歆玥","totalMsgCount":11504},{"targetName":"我北芭直女天花板是也","targetAvatar":"/20210113/16104732799470775UJ1z7S.jpg","targetType":0,"targetId":"67236634","msg":"🤭太考验技术了…","msgTime":1621774509237,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"327580","ownerName":"BEJ48-张梦慧","totalMsgCount":15333},{"targetName":"不吃芒果了再也不吃了","targetAvatar":"/20210517/1621199683158mr54fgt5kg.jpg","targetType":0,"targetId":"155333671","msg":"这几天吃鸡有点厉害","msgTime":1621774426771,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"6827278357","ownerName":"GNZ48-吴思琪","totalMsgCount":26323},{"targetName":"佩佩","targetAvatar":"/20200905/15993052442517JS3A20I1V.jpg","targetType":0,"targetId":"67284411","msg":"我们的unit在第二part第二首","msgTime":1621774402431,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"63562","ownerName":"GNZ48-林嘉佩","totalMsgCount":29039},{"targetName":"🦉","targetAvatar":"/mediasource/avatar/327567gFa9N4GB70.jpg","targetType":0,"targetId":"67342026","msg":"我像在摇花手","msgTime":1621774120638,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327567","ownerName":"GNZ48-刘力菲","totalMsgCount":38903},{"targetName":"🌫","targetAvatar":"/20210401/1617258935467xvosmq82v8.jpg","targetType":0,"targetId":"67275553","msg":"等待起飞","msgTime":1621773998930,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"677404","ownerName":"SNH48-周诗雨","totalMsgCount":28512},{"targetName":"西米的小天地","targetAvatar":"/20210521/162159860934910z877m88d.jpg","targetType":0,"targetId":"377982661","msg":"[直播消息]","msgTime":1621773987187,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526097","ownerName":"SNH48-禹佳蔚","totalMsgCount":1076},{"targetName":"耶耶","targetAvatar":"/20210501/1619883046674pfgegl6xhh.jpg","targetType":0,"targetId":"67380556","msg":"飞了飞了","msgTime":1621773951906,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"327577","ownerName":"GNZ48-左婧媛","totalMsgCount":19514},{"targetName":"🍼幸运欧气都给蕊","targetAvatar":"/20210505/1620219896304d6qw3tw5zd.jpg","targetType":0,"targetId":"67275492","msg":"[翻牌消息]","msgTime":1621773720475,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"460005","ownerName":"SNH48-赵佳蕊","totalMsgCount":25673},{"targetName":"🌦️","targetAvatar":"/20210514/1620986943565i9c9tvhtxq.jpg","targetType":0,"targetId":"67391027","msg":"早点睡觉哦哦哦哦","msgTime":1621773630297,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"874701","ownerName":"GNZ48-张润","totalMsgCount":64594},{"targetName":"守得云开见月明","targetAvatar":"/20210522/162167892050897yhxry03b.jpg","targetType":0,"targetId":"67207933","msg":"我去洗个澡","msgTime":1621773614705,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"874508","ownerName":"IDFT-尚官","totalMsgCount":4888},{"targetName":"👧🏻","targetAvatar":"/20200811/15971552663526J4ZEt6HT2.jpg","targetType":0,"targetId":"67313897","msg":"[拳头]","msgTime":1621773439172,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"607513","ownerName":"GNZ48-符冰冰","totalMsgCount":44247},{"targetName":"✨猫的天空之城✨","targetAvatar":"/20210514/1620962655033wh91g69iyl.jpg","targetType":0,"targetId":"67189785","msg":"所以让你早上去呀","msgTime":1621773411483,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327563","ownerName":"GNZ48-陈楠茜","totalMsgCount":20997},{"targetName":"🐻🍬","targetAvatar":"/20210509/1620539986726dmnfec43ad.jpeg","targetType":0,"targetId":"224670690","msg":"[直播消息]","msgTime":1621773393328,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"39911923","ownerName":"CKG48-潘颖","totalMsgCount":13481},{"targetName":"爽爽的QQ空间","targetAvatar":"/20210506/1620230412807q0iigs84z5.jpg","targetType":0,"targetId":"67275562","msg":"[翻牌消息]","msgTime":1621773291704,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"867892","ownerName":"SNH48-郭爽","totalMsgCount":19945},{"targetName":"正义使者和怂怂的🏠","targetAvatar":"/20210506/1620294760837b9czhddvkb.jpg","targetType":0,"targetId":"387989957","msg":"出门忘记看黄历","msgTime":1621773122124,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"52494490","ownerName":"GNZ48-郑奕雯","totalMsgCount":1012},{"targetName":"好运来","targetAvatar":"/20210504/1620061955740xozjmgrtfy.jpg","targetType":0,"targetId":"67199643","msg":"我们开始了！！！rock","msgTime":1621773080854,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614761","ownerName":"CKG48-吴学雨","totalMsgCount":28773},{"targetName":"前方207米记得转弯","targetAvatar":"/20210517/1621264763834boa6015yd2.jpg","targetType":0,"targetId":"377979685","msg":"[直播消息]","msgTime":1621773056839,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526098","ownerName":"SNH48-张冉冉","totalMsgCount":2859},{"targetName":"💎","targetAvatar":"/20210520/1621443173533vcjuhpmnwy.jpg","targetType":0,"targetId":"67199568","msg":"太困了 溜了溜了886","msgTime":1621772997546,"icon":[],"ownerId":"38","ownerName":"戴萌","totalMsgCount":8010},{"targetName":"精神百倍","targetAvatar":"/20200818/15977623635666q2JxHB5hl.jpg","targetType":0,"targetId":"67303246","msg":"[凋谢]","msgTime":1621772992937,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"407121","ownerName":"SNH48-孙语姗","totalMsgCount":10808},{"targetName":".","targetAvatar":"/20190605/1559696548274XgOpuMCiWv.jpg","targetType":0,"targetId":"67217571","msg":"有史以来最快的出工收工～","msgTime":1621772962346,"icon":[],"ownerId":"39","ownerName":"吴哲晗","totalMsgCount":7524},{"targetName":"Neverland","targetAvatar":"/20210210/1612930008796g6qsprjh65.jpg","targetType":0,"targetId":"67342133","msg":"活得像个外地人","msgTime":1621772900595,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614735","ownerName":"CKG48-田倩兰","totalMsgCount":23052},{"targetName":"小晴の糖果屋🍬","targetAvatar":"/20210501/1619830357934c292b62i1a.jpg","targetType":0,"targetId":"67352370","msg":"[直播消息]","msgTime":1621772816622,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"874505","ownerName":"IDFT-刘宇晴","totalMsgCount":24768},{"targetName":"小番茄不在家","targetAvatar":"/20210313/16156060878480exbl63nvx.jpg","targetType":0,"targetId":"67322562","msg":"发现手机没了🙉","msgTime":1621772706478,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"867891","ownerName":"GNZ48-方琪","totalMsgCount":33923},{"targetName":"二欣咿呀咿呀哟","targetAvatar":"/20210210/1612940244647r6403ln14c.jpg","targetType":0,"targetId":"67391028","msg":"好的 那就这个发型先做个三个月起 😂","msgTime":1621772697238,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"874723","ownerName":"GNZ48-王梓","totalMsgCount":11744},{"targetName":"黑金VIP Club","targetAvatar":"/20210208/1612769705907uxz6fwa9an.jpg","targetType":0,"targetId":"67265498","msg":"😂😂","msgTime":1621772517980,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"528335","ownerName":"BEJ48-金锣赛","totalMsgCount":23870},{"targetName":"STARTREK🛸","targetAvatar":"/20210512/1620811121830tijm60gnho.jpg","targetType":0,"targetId":"377988067","msg":"[直播消息]","msgTime":1621772495296,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526102","ownerName":"SNH48-张月铭","totalMsgCount":1908},{"targetName":"✨此广告位长期招租✨","targetAvatar":"/20210117/1610878943569T00jh30EKz.jpg","targetType":0,"targetId":"187441935","msg":"[直播消息]","msgTime":1621772469607,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"9276751977","ownerName":"CKG48-梁晶金","totalMsgCount":10747},{"targetName":"苏杉杉bot⚡","targetAvatar":"/20201031/1604153018757PmglKhG9z1.jpg","targetType":0,"targetId":"67362271","msg":"[直播消息]","msgTime":1621772467277,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"327597","ownerName":"SNH48-苏杉杉","totalMsgCount":28895},{"targetName":"文社社长","targetAvatar":"/20210410/1618040844975icsm7sebmv.jpg","targetType":0,"targetId":"159822189","msg":"后半场都在 放心","msgTime":1621772350682,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"5602541574","ownerName":"SNH48-由淼","totalMsgCount":38131},{"targetName":"不知名垃圾堆上的乌鸦","targetAvatar":"/20210222/16139855062505n45lrt973.jpg","targetType":0,"targetId":"67380616","msg":"今天也是抢装上mc3喔","msgTime":1621772247192,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"614741","ownerName":"GNZ48-曾佳","totalMsgCount":14284},{"targetName":"ʚ🍒ྀིɞ","targetAvatar":"/20201119/160576102978336n5YEr69S.jpg","targetType":0,"targetId":"67370603","msg":"[直播消息]","msgTime":1621772208367,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"679455","ownerName":"CKG48-刁滢","totalMsgCount":5539},{"targetName":"要成为海贼王的男人","targetAvatar":"/mediasource/room/1553350580368y7A6x3HcAQ.jpg","targetType":0,"targetId":"67390999","msg":"[直播消息]","msgTime":1621772046608,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"624121","ownerName":"SNH48-何阳青青","totalMsgCount":21093},{"targetName":"M78星云资深小邋遢表演艺术家","targetAvatar":"/20190818/1566114302953Ijjy60237W.jpg","targetType":0,"targetId":"67265389","msg":"[直播消息]","msgTime":1621771936417,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"399631","ownerName":"SNH48-吕一","totalMsgCount":15531},{"targetName":"云艺最幽默的人 嘻","targetAvatar":"/20210405/1617553947494f7iaq4pgi9.jpg","targetType":0,"targetId":"67236697","msg":"[图片消息]","msgTime":1621771879517,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"867895","ownerName":"CKG48-彭榆涵","totalMsgCount":12436},{"targetName":"小王霸乐园","targetAvatar":"/20200926/160112522890361t6o7a4YI.jpg","targetType":0,"targetId":"67362351","msg":"[直播消息]","msgTime":1621771543062,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"614727","ownerName":"GNZ48-李姗姗","totalMsgCount":122038},{"targetName":"No偶像包袱的朋友圈","targetAvatar":"/20210516/1621166909430lp5eju3hh3.jpg","targetType":0,"targetId":"377992915","msg":"[直播消息]","msgTime":1621771512109,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526093","ownerName":"SNH48-林佳怡","totalMsgCount":2569},{"targetName":"鹿言鹿语✨","targetAvatar":"/20210325/1616685749173bwzza4f6s6.jpg","targetType":0,"targetId":"144655472","msg":"[直播消息]","msgTime":1621771427952,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"4344250374","ownerName":"SNH48-潘璐瑶","totalMsgCount":23385},{"targetName":"孙珍妮","targetAvatar":"/20190728/1564289265078yKwVard99S.jpg","targetType":0,"targetId":"67390920","msg":"冲冲冲","msgTime":1621771415099,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"286977","ownerName":"SNH48-孙珍妮","totalMsgCount":10037},{"targetName":"403号宇宙飞船","targetAvatar":"/20210502/16199544223640k3ov5gbps.jpg","targetType":0,"targetId":"377987247","msg":"[直播消息]","msgTime":1621771329826,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"54526095","ownerName":"SNH48-武博涵","totalMsgCount":4830},{"targetName":"是祁静船长的海盗船☻","targetAvatar":"/20210317/16159318744555ioa2sgwcb.jpg","targetType":0,"targetId":"67313798","msg":"🤭","msgTime":1621771324412,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"399672","ownerName":"SNH48-祁静","totalMsgCount":24166},{"targetName":"魔导士培训班","targetAvatar":"/20210316/16158939397118wvfxcypdv.jpg","targetType":0,"targetId":"67199629","msg":"学院好可怕[发抖]","msgTime":1621771234787,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"601302","ownerName":"GNZ48-梁婉琳","totalMsgCount":14541},{"targetName":"我是闫明筠【比心","targetAvatar":"/20210301/1614592683432aj4fyxo44f.jpg","targetType":0,"targetId":"67333066","msg":"俺加快速度QvQ","msgTime":1621771165101,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"6745","ownerName":"SNH48-闫明筠","totalMsgCount":9771},{"targetName":"乐窝","targetAvatar":"/20210515/162101674650695fp0blkcx.jpg","targetType":0,"targetId":"67189813","msg":"冒泡现在已经困到外面放烟花都不感兴趣了","msgTime":1621771056756,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"459999","ownerName":"SNH48-韩家乐","totalMsgCount":11756},{"targetName":"慌聚一堂✨","targetAvatar":"/20200803/15964628729305AIQ7RGhBQ.jpg","targetType":0,"targetId":"67246058","msg":"像一窝小鸡🐤","msgTime":1621770971422,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327568","ownerName":"GNZ48-刘倩倩","totalMsgCount":38377},{"targetName":"星🌟想事成","targetAvatar":"/20201231/1609403490742z0c5LnQ969.jpg","targetType":0,"targetId":"248621211","msg":"[直播消息]","msgTime":1621770938167,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"42402769","ownerName":"SNH48-李星彦","totalMsgCount":9862},{"targetName":"傻fufu快乐屋🌟","targetAvatar":"/20210522/16216367295768osyqf4qe7.jpg","targetType":0,"targetId":"248613346","msg":"陈妮亚啊 我真是 不知道怎么说好了","msgTime":1621770863060,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"42402830","ownerName":"SNH48-曲晨语","totalMsgCount":25032},{"targetName":"孙芮","targetAvatar":"/20200115/1579055863322vD54Cg4620.png","targetType":0,"targetId":"67322480","msg":".....","msgTime":1621770736758,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"8","ownerName":"SNH48-孙芮","totalMsgCount":9304},{"targetName":"性感娇花的房间","targetAvatar":"/20201225/1608873692775c2jOdXvQVd.jpg","targetType":0,"targetId":"67236669","msg":"是个有钱的坏孩子[傲慢]","msgTime":1621770693206,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"607523","ownerName":"GNZ48-林芝","totalMsgCount":79933},{"targetName":"燕窝","targetAvatar":"/20210113/161047355951979rcA2OBlE.jpg","targetType":0,"targetId":"67303279","msg":"越看越可爱的程度🐶","msgTime":1621770685395,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"528329","ownerName":"BEJ48-孙晓艳","totalMsgCount":17103},{"targetName":"y3⭕⭕","targetAvatar":"/20200725/1595663195267W4Tz2T1X0W.jpg","targetType":0,"targetId":"67342057","msg":"有沙雕粉入坑吗！","msgTime":1621770683347,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417331","ownerName":"GNZ48-杨媛媛","totalMsgCount":25302},{"targetName":"🥚胖丁之家🥚","targetAvatar":"/20210210/1612956307149fz22ji91kn.jpg","targetType":0,"targetId":"261495713","msg":"🤫","msgTime":1621770577278,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285677","ownerName":"BEJ48-黄妍菲","totalMsgCount":19083},{"targetName":"Lazy Lover","targetAvatar":"/20210506/1620273242285pjab3lil2h.jpg","targetType":0,"targetId":"154058194","msg":"嘿嘿嘿","msgTime":1621770562976,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"4998561802","ownerName":"SNH48-宁轲","totalMsgCount":20543},{"targetName":"老年复健少女偶像","targetAvatar":"/20210320/1616170472924g96dpkykfh.jpg","targetType":0,"targetId":"181393187","msg":"在吃饭啦","msgTime":1621770124894,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"8957984817","ownerName":"GNZ48-石竹君","totalMsgCount":46167},{"targetName":"喜笑颜开","targetAvatar":"/20201006/1601977550732m7G5zGT2c4.jpg","targetType":0,"targetId":"67189767","msg":"我去吃饭啦","msgTime":1621770103183,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327572","ownerName":"GNZ48-冼燊楠","totalMsgCount":18995},{"targetName":"快乐大学生👩‍🎓","targetAvatar":"/20210510/1620629390239mmyddbs88f.jpg","targetType":0,"targetId":"67333084","msg":"来分享喜悦咯","msgTime":1621769857785,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"63561","ownerName":"SNH48-蒋舒婷","totalMsgCount":11044},{"targetName":"1","targetAvatar":"/20210413/16183125920819c7rmbewvd.jpg","targetType":0,"targetId":"67380608","msg":"是昨天没穿短袖的我了","msgTime":1621769521172,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"594003","ownerName":"SNH48-王奕","totalMsgCount":15239},{"targetName":"快乐变态","targetAvatar":"/20201118/1605688057239xCct4iU66b.jpg","targetType":0,"targetId":"67236636","msg":"[图片消息]","msgTime":1621769455989,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"5566","ownerName":"SNH48-许杨玉琢","totalMsgCount":16982},{"targetName":"今日晴","targetAvatar":"/20210521/1621574933806yeo4dkebq2.jpg","targetType":0,"targetId":"261498409","msg":"一会儿见","msgTime":1621768579321,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285685","ownerName":"BEJ48-黄宣绮","totalMsgCount":32825},{"targetName":"吸猫会所","targetAvatar":"/20191112/1573492079574Af6rW47e87.jpg","targetType":0,"targetId":"67265421","msg":"在旁边坐了半小时","msgTime":1621768436557,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"49005","ownerName":"SNH48-沈梦瑶","totalMsgCount":14688},{"targetName":"挖哥哥🚜","targetAvatar":"/20210305/1614943549391pq86f93qip.jpg","targetType":0,"targetId":"67246085","msg":"收到礼物了🎁 谢谢 呜呜","msgTime":1621768368363,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"11","ownerName":"SNH48-温晶婕","totalMsgCount":8758},{"targetName":"+n的加油站","targetAvatar":"/20210506/1620288794852no1tp869fh.jpg","targetType":0,"targetId":"67199599","msg":"今天还有课要补[流泪]提早来学校了","msgTime":1621768278072,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"286983","ownerName":"SNH48-李佳恩","totalMsgCount":2724},{"targetName":"快来快来","targetAvatar":"/20210401/1617253975446l54t4qnm2u.jpg","targetType":0,"targetId":"261502245","msg":"等会公演见^_^","msgTime":1621768191439,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285682","ownerName":"BEJ48-黄怡慈","totalMsgCount":18988},{"targetName":"所念皆星河✨","targetAvatar":"/20210111/1610373569915OYv71Q6j9L.jpg","targetType":0,"targetId":"67189871","msg":"我是魔法少女我是会飞的","msgTime":1621768145878,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"711726","ownerName":"GNZ48-高蔚然","totalMsgCount":20873},{"targetName":"你的快乐小‘佳’","targetAvatar":"/20210117/16108849012310imP94v9N4.jpg","targetType":0,"targetId":"67333045","msg":"真的","msgTime":1621767933598,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"327571","ownerName":"GNZ48-唐莉佳","totalMsgCount":27197},{"targetName":"要成为☀","targetAvatar":"/mediasource/room/1550121833160pKF7Z938Yj.jpg","targetType":0,"targetId":"67390993","msg":"[直播消息]","msgTime":1621767904310,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"614776","ownerName":"IDFT-吴晶晶","totalMsgCount":16},{"targetName":"可乐吨吨机","targetAvatar":"/20210203/161235855118502yZ1AclUh.jpg","targetType":0,"targetId":"67293874","msg":"[直播消息]","msgTime":1621767883106,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"327587","ownerName":"SNH48-冯思佳","totalMsgCount":21883},{"targetName":"亲自可爱💛🔨","targetAvatar":"/20210115/1610641733924iOV9MwP90H.jpg","targetType":0,"targetId":"114030785","msg":"忘记叫啥了","msgTime":1621767282758,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"480680","ownerName":"CKG48-张幼柠","totalMsgCount":18509},{"targetName":"小🐏出没，注意安全","targetAvatar":"/20201103/16043986857844c31xmL0N1.jpg","targetType":0,"targetId":"67275547","msg":"啊啊啊我好社恐嗷😭","msgTime":1621767277607,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"711741","ownerName":"SNH48-杨宇馨","totalMsgCount":23870},{"targetName":"邀请你加入群聊","targetAvatar":"/20210518/1621319054936rm7sbtj1l4.jpg","targetType":0,"targetId":"67362328","msg":"但是睡不着","msgTime":1621767148419,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"530390","ownerName":"SNH48-王睿琦","totalMsgCount":96306},{"targetName":"死不回头🎵","targetAvatar":"/20210410/16180344126508h1lsh552b.jpg","targetType":0,"targetId":"67370538","msg":"我怕遁入自我空间之后 突然告诉我该我了 然后一片空白稿子","msgTime":1621766935624,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"327561","ownerName":"CKG48-周倩玉","totalMsgCount":30339},{"targetName":"茜里哗啦","targetAvatar":"/20200829/1598667191482m2yYV7iPqY.jpg","targetType":0,"targetId":"67370606","msg":"拜拜红龙果[微笑]","msgTime":1621766785252,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"677403","ownerName":"SNH48-张茜","totalMsgCount":8424},{"targetName":"🚂火车站协调总部","targetAvatar":"/20201107/16046999521760qFM7b941o.jpg","targetType":0,"targetId":"67236680","msg":"[图片消息]","msgTime":1621766334061,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"614753","ownerName":"SNH48-郝婧怡","totalMsgCount":15013},{"targetName":"天机泄漏处","targetAvatar":"/20210315/16158122979327mqnwya8n7.jpg","targetType":0,"targetId":"147283635","msg":"到对面小店去一下","msgTime":1621766269107,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"4344250371","ownerName":"SNH48-陈雨孜","totalMsgCount":23350},{"targetName":"一颗QQ星🌟","targetAvatar":"/20210420/161892584810210pioo47r6.jpg","targetType":0,"targetId":"67275548","msg":"搞定！👌🏻","msgTime":1621766231740,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"711735","ownerName":"BEJ48-曲美霖","totalMsgCount":12796},{"targetName":"栗子铺🌰","targetAvatar":"/20191022/1571720909850sSz5CqY781.jpg","targetType":0,"targetId":"67303248","msg":"[图片消息]","msgTime":1621766023252,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"63582","ownerName":"SNH48-张怡","totalMsgCount":7645},{"targetName":"🪐","targetAvatar":"/20210413/1618320451719gv0h21l34o.jpg","targetType":0,"targetId":"67265436","msg":"不好意思(._.)我口袋有点问题有时候有些翻牌翻不到(._.)","msgTime":1621765740653,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"2508","ownerName":"SNH48-张昕","totalMsgCount":25468},{"targetName":"🌱","targetAvatar":"/20210421/1618997809336fkp8d4t916.jpg","targetType":0,"targetId":"67199579","msg":"还是饿","msgTime":1621765339326,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327566","ownerName":"GNZ48-洪静雯","totalMsgCount":28334},{"targetName":"小金鱼的缸🛁","targetAvatar":"/20210421/1618981179462j2udao3nn2.jpg","targetType":0,"targetId":"67313885","msg":"晚上好呀","msgTime":1621765150672,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"530440","ownerName":"CKG48-赖俊亦","totalMsgCount":18379},{"targetName":"幼儿园拽姐😎","targetAvatar":"/20200922/1600746074456t686iymXyB.jpg","targetType":0,"targetId":"170000713","msg":"[直播消息]","msgTime":1621765026694,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"4344250373","ownerName":"CKG48-江鑫","totalMsgCount":13110},{"targetName":"🎬沈氏集团✨","targetAvatar":"/20210401/1617274668859z1h9k6e6wt.jpg","targetType":0,"targetId":"67293879","msg":"[跳跳]","msgTime":1621764590945,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"63577","ownerName":"GNZ48-曾艾佳","totalMsgCount":34921},{"targetName":"奶茶不加冰","targetAvatar":"/20210505/1620218829421944yfpij7y.jpg","targetType":0,"targetId":"67275431","msg":"[呲牙]","msgTime":1621764577229,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"6737","ownerName":"SNH48-邵雪聪","totalMsgCount":5097},{"targetName":"𓃟𓃟𓃟𓃟𓃟","targetAvatar":"/20210514/1620988286506cxgru30v4j.jpg","targetType":0,"targetId":"67217596","msg":"哦哦哦现在是晚上了呀","msgTime":1621764560315,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327569","ownerName":"GNZ48-卢静","totalMsgCount":80159},{"targetName":"进来说话💬","targetAvatar":"/mediasource/room/1531935482308zU3usafrq2.jpg","targetType":0,"targetId":"67275543","msg":"🥵","msgTime":1621764546262,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"679464","ownerName":"CKG48-王嘉瑜","totalMsgCount":21506},{"targetName":"淇乐融融💚","targetAvatar":"/20210323/1616511581899awel9fsw95.jpg","targetType":0,"targetId":"67380660","msg":"今天也辛苦了~","msgTime":1621764509115,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"874696","ownerName":"GNZ48-叶舒淇","totalMsgCount":30428},{"targetName":"我❤️芭","targetAvatar":"/20210126/1611668246590LKWlJ423CK.jpg","targetType":0,"targetId":"67275528","msg":"勉强让他睡会吧","msgTime":1621764116014,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"614528","ownerName":"SNH48-柏欣妤","totalMsgCount":33107},{"targetName":"这个房间的主人很漂亮","targetAvatar":"/20200930/160144694384294SRmZ8rtx.jpg","targetType":0,"targetId":"67275458","msg":"厉害了你们","msgTime":1621763866348,"icon":[],"ownerId":"36","ownerName":"钱蓓婷","totalMsgCount":9041},{"targetName":"🥚","targetAvatar":"/20200602/1591092131637g7inz7v6EU.jpg","targetType":0,"targetId":"67256340","msg":"[图片消息]","msgTime":1621763587495,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"327575","ownerName":"GNZ48-郑丹妮","totalMsgCount":27422},{"targetName":"獭獭之家🦦","targetAvatar":"/20210521/1621607824387rcq6d0u6sg.jpg","targetType":0,"targetId":"67333093","msg":"上班💼","msgTime":1621763559174,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6744","ownerName":"SNH48-杨冰怡","totalMsgCount":41048},{"targetName":"千纸鹤翻糖蛋糕🍰","targetAvatar":"/20210319/1616168265022ss13w4c3pw.jpg","targetType":0,"targetId":"67342150","msg":"外面在下雨吗！","msgTime":1621763547446,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"609002","ownerName":"SNH48-赵天杨","totalMsgCount":29908},{"targetName":"自信研究所","targetAvatar":"/20210421/16189983356243p8re0sz26.jpg","targetType":0,"targetId":"67352296","msg":"和大家聊天很开心～","msgTime":1621763480959,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417329","ownerName":"GNZ48-王秭歆","totalMsgCount":29270},{"targetName":"树蛙在干嘛","targetAvatar":"/20210223/1614071171961l550k1f1pi.jpg","targetType":0,"targetId":"67390996","msg":"热化了！","msgTime":1621762949631,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614728","ownerName":"CKG48-雷宇霄","totalMsgCount":29469},{"targetName":"随缘打开","targetAvatar":"/20200906/1599404451525tRk11gVjCw.jpg","targetType":0,"targetId":"67322491","msg":"那你还是差了点","msgTime":1621761775994,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"63566","ownerName":"SNH48-刘增艳","totalMsgCount":11891},{"targetName":"花开富贵","targetAvatar":"/20210412/161822188257430sq70sofb.jpg","targetType":0,"targetId":"67236584","msg":"饭后再来","msgTime":1621761765675,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"327581","ownerName":"SNH48-青钰雯","totalMsgCount":12741},{"targetName":"✨💡✨","targetAvatar":"/20210303/1614709333639a1bxgfq7fj.jpg","targetType":0,"targetId":"67333149","msg":"表妹：不想去😂","msgTime":1621761488355,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"607511","ownerName":"GNZ48-邓惠恩","totalMsgCount":16057},{"targetName":"整个一个大营业的动作","targetAvatar":"/20210502/16199407416326cy9oi5jfb.jpg","targetType":0,"targetId":"67362340","msg":"没确定还","msgTime":1621761290297,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"530439","ownerName":"CKG48-高雪逸","totalMsgCount":14079},{"targetName":"Pizzaboy🍕","targetAvatar":"/20210415/1618426859934wds20wgitg.jpg","targetType":0,"targetId":"67275416","msg":"我在dy看到的","msgTime":1621760954027,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"327579","ownerName":"SNH48-刘姝贤","totalMsgCount":42959},{"targetName":"睡睡睡不醒","targetAvatar":"/20200418/1587196887248G06G2h8KF2.jpg","targetType":0,"targetId":"67246114","msg":"准备公演啦","msgTime":1621760895656,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614733","ownerName":"CKG48-谯玉珍","totalMsgCount":13944},{"targetName":"谢谢你喜欢嘻嘻子","targetAvatar":"/20210422/1619068587510fepka4py91.jpg","targetType":0,"targetId":"181380525","msg":"感觉路上好塞车噢现在","msgTime":1621759957902,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"8957984818","ownerName":"GNZ48-杨若惜","totalMsgCount":47217},{"targetName":"相亲相爱一家人🌝","targetAvatar":"/20210510/162065895993327488eq2km.jpg","targetType":0,"targetId":"248619173","msg":"嗷呜","msgTime":1621757265046,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"42402741","ownerName":"SNH48-闫娜","totalMsgCount":6980},{"targetName":"哆啦哆啦！","targetAvatar":"/20200221/15822928495104mZP579eU0.jpg","targetType":0,"targetId":"67284424","msg":"嘿嘿","msgTime":1621756661883,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"63560","ownerName":"SNH48-姜杉","totalMsgCount":10250},{"targetName":"LG☁️","targetAvatar":"/20210519/16214245132422w0obae1gs.jpg","targetType":0,"targetId":"155345469","msg":"我6月回去","msgTime":1621755595376,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"6827278356","ownerName":"GNZ48-刘果","totalMsgCount":30055},{"targetName":"源崽的房间","targetAvatar":"/20201229/1609227162829p118jP9JZe.jpg","targetType":0,"targetId":"67265467","msg":"鱼真的只有七秒记忆吗？？","msgTime":1621755564058,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"63555","ownerName":"SNH48-费沁源","totalMsgCount":17408},{"targetName":"星球🌍","targetAvatar":"/20210119/16110287787981xpn027l5l.jpg","targetType":0,"targetId":"67189812","msg":"我一度感觉椅子要塌了","msgTime":1621755309643,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"459991","ownerName":"SNH48-卢天惠","totalMsgCount":10886},{"targetName":"洪崖洞洞主⛰️","targetAvatar":"/20210310/1615353289870df490sovi5.jpg","targetType":0,"targetId":"261489758","msg":"呜呜呜","msgTime":1621754673656,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285674","ownerName":"BEJ48-胡雪迎","totalMsgCount":10679},{"targetName":"是没有草字头的宣;)","targetAvatar":"/20210325/1616611975140o305p2cc9c.jpg","targetType":0,"targetId":"67313737","msg":"晚上加油👾","msgTime":1621754524331,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417321","ownerName":"GNZ48-农燕萍","totalMsgCount":33220},{"targetName":"你的小晴（武汉版💅","targetAvatar":"/20200823/159812740275069p8m6kMqv.jpg","targetType":0,"targetId":"67256384","msg":"哦耶做回女人咯","msgTime":1621754466913,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"614756","ownerName":"SNH48-林舒晴","totalMsgCount":34124},{"targetName":"毛译晗","targetAvatar":"/20201224/1608797979372d80zQNNNA4.jpg","targetType":0,"targetId":"67333166","msg":"可以可以[偷笑]","msgTime":1621752896937,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614731","ownerName":"CKG48-毛译晗","totalMsgCount":8027},{"targetName":"欢迎光临我的宇宙","targetAvatar":"/20200407/15862413731451OUswqDi8u.jpg","targetType":0,"targetId":"67199602","msg":"📝","msgTime":1621750416520,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417325","ownerName":"GNZ48-王炯义","totalMsgCount":9900},{"targetName":"刘弋菡的qq群","targetAvatar":"/20210121/1611201453580n0Ttu74AmW.jpg","targetType":0,"targetId":"67390997","msg":"下午好😃","msgTime":1621750170374,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"614750","ownerName":"CKG48-刘弋菡","totalMsgCount":8750},{"targetName":"bb","targetAvatar":"/20210403/16174533939221l79x24uws.jpg","targetType":0,"targetId":"67284494","msg":"大家一定要戴口罩呀呀呀呀[大哭]","msgTime":1621750112744,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"874500","ownerName":"IDFT-冯嘉宝","totalMsgCount":5429},{"targetName":"在洁难逃","targetAvatar":"/20200819/1597776039832Bmm1S446Yg.jpg","targetType":0,"targetId":"67284493","msg":"我不行了，一打开就……","msgTime":1621748948869,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"868352","ownerName":"SNH48-刘洁","totalMsgCount":12058},{"targetName":"灿烂打工人！୧😂୨","targetAvatar":"/20210522/1621620973925l9xg64myg6.jpg","targetType":0,"targetId":"67293956","msg":"下午好","msgTime":1621747273702,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"538697","ownerName":"SNH48-沈小爱","totalMsgCount":24666},{"targetName":"杨允涵","targetAvatar":"/20210414/1618412622637h92von0vx5.jpg","targetType":0,"targetId":"67390969","msg":"୧(﹒︠ᴗ﹒︡)୨","msgTime":1621745811543,"icon":["/20210518/16213099186970lapqp5g8z.png"],"ownerId":"460004","ownerName":"CKG48-杨允涵","totalMsgCount":15631},{"targetName":"一只小沁","targetAvatar":"/20201224/1608797301234SqLUZ383sI.jpg","targetType":0,"targetId":"67256413","msg":"谢谢TOTO的夜蝶子🦋","msgTime":1621745421619,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"881190","ownerName":"SNH48-颜沁","totalMsgCount":10994},{"targetName":"🐑","targetAvatar":"/20190603/1559555255917wCbNIY8EmT.jpg","targetType":0,"targetId":"67390950","msg":"[图片消息]","msgTime":1621742099806,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"417330","ownerName":"GNZ48-杨可璐","totalMsgCount":35647},{"targetName":"奇妙小罗","targetAvatar":"/20210501/1619834764232746g8ubs3b.jpg","targetType":0,"targetId":"67217562","msg":"很香","msgTime":1621737369709,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"327558","ownerName":"GNZ48-罗寒月","totalMsgCount":16662},{"targetName":"💥","targetAvatar":"/20200928/1601224503752u733817prK.jpg","targetType":0,"targetId":"67256337","msg":"应该感觉好点了吧","msgTime":1621733831523,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"17","ownerName":"SNH48-蒋芸","totalMsgCount":6068},{"targetName":"支棱起来谢谢","targetAvatar":"/20210102/1609574652308c0f8IokAgv.jpg","targetType":0,"targetId":"67303290","msg":"早上好","msgTime":1621731168616,"icon":["/mediasource/teamLogo2/all/gnz48_n3.png"],"ownerId":"530447","ownerName":"GNZ48-谢艾琳","totalMsgCount":13587},{"targetName":"健康阿宅的房间","targetAvatar":"/20210507/1620399901044841djff114.jpg","targetType":0,"targetId":"67189770","msg":"现在的外卖太好了吧","msgTime":1621709340173,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"34","ownerName":"SNH48-陆婷","totalMsgCount":1204},{"targetName":"才不要做傻白甜","targetAvatar":"/20200526/15904377813027mzD5soReG.jpg","targetType":0,"targetId":"67333062","msg":"[音频消息]","msgTime":1621704304356,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"63554","ownerName":"SNH48-段艺璇","totalMsgCount":25371},{"targetName":"0.0","targetAvatar":"/20210112/16104218084370Xwurs7Il5.jpg","targetType":0,"targetId":"67380527","msg":"恭喜DK！","msgTime":1621702985965,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"327574","ownerName":"IDFT-熊心瑶","totalMsgCount":7890},{"targetName":"投递日常😉","targetAvatar":"/20210405/16175604155425fwd7ya4xk.jpg","targetType":0,"targetId":"67370548","msg":"晚安","msgTime":1621702803642,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"63572","ownerName":"GNZ48-谢蕾蕾","totalMsgCount":13292},{"targetName":"宋牛牛🐮","targetAvatar":"/20210210/1612964559727kru01kol52.jpg","targetType":0,"targetId":"67352254","msg":"深夜舞蹈房🕺🏻","msgTime":1621701825080,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6738","ownerName":"SNH48-宋昕冉","totalMsgCount":8413},{"targetName":"🉑️阳光快乐屋☀️","targetAvatar":"/20210228/1614494626024ybgomlw6sc.jpg","targetType":0,"targetId":"67246060","msg":"好吧晚安子","msgTime":1621701451224,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"63548","ownerName":"GNZ48-陈珂","totalMsgCount":16437},{"targetName":"宝山沈从文","targetAvatar":"/20210225/1614226059401o3b20lu18m.jpg","targetType":0,"targetId":"67217613","msg":"好惨😢","msgTime":1621700646673,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"5574","ownerName":"SNH48-张雨鑫","totalMsgCount":5176},{"targetName":"东海龙宫首席龙女","targetAvatar":"/20210520/1621485125278a3n5e4zfr8.jpg","targetType":0,"targetId":"67370575","msg":"早点休息哦","msgTime":1621700311220,"icon":["/mediasource/teamLogo2/all/snh48_n2.png"],"ownerId":"538735","ownerName":"SNH48-金莹玥","totalMsgCount":16836},{"targetName":"麦芽喵喜欢吃麦芽糖","targetAvatar":"/20200923/160083230157527aJwNjoaa.jpg","targetType":0,"targetId":"67275559","msg":"但是又确实有点热🌚","msgTime":1621699195043,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"831078","ownerName":"BEJ48-任蔓琳","totalMsgCount":25906},{"targetName":"🌼❤️","targetAvatar":"/20210508/1620434873534537wthb32n.jpg","targetType":0,"targetId":"67189884","msg":"袁爷爷看着我们吃饱饭才走的，所以以后的每一顿饭都要好好吃完，不要浪费呀🌾","msgTime":1621696596659,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"867896","ownerName":"IDFT-田密","totalMsgCount":423},{"targetName":"小小世界🌎","targetAvatar":"/20210317/1615991636854hs7ja2sw77.jpg","targetType":0,"targetId":"67207922","msg":"晚安啦💤","msgTime":1621696220210,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"711746","ownerName":"BEJ48-周湘","totalMsgCount":30529},{"targetName":"歪歪仔在此","targetAvatar":"/20210221/1613914636530v9ih1899kn.jpg","targetType":0,"targetId":"67265391","msg":"[翻牌消息]","msgTime":1621695475555,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"5","ownerName":"SNH48-袁雨桢","totalMsgCount":7026},{"targetName":"小her的小角落","targetAvatar":"/20210211/161305575197671m1h2ejpj.jpg","targetType":0,"targetId":"67333041","msg":"打车走的时候久违的感受到了公演下班的送车环节哈哈哈哈","msgTime":1621682690735,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"407106","ownerName":"SNH48-黄恩茹","totalMsgCount":6621},{"targetName":"不可思议的梦幻屋","targetAvatar":"/20191112/15735673036488boeF5ibx0.jpg","targetType":0,"targetId":"67284386","msg":"今天太悲痛了","msgTime":1621680412072,"icon":[],"ownerId":"18","ownerName":"徐晨辰","totalMsgCount":12095},{"targetName":"马玉灵机一动","targetAvatar":"/20191101/1572578354858T6t1dT3kPK.jpg","targetType":0,"targetId":"67342074","msg":"那就晚安啦","msgTime":1621610279502,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"327596","ownerName":"SNH48-马玉灵","totalMsgCount":36264},{"targetName":"翻记录会哭","targetAvatar":"/20190415/1555325898266nNQEJfC248.jpg","targetType":0,"targetId":"67217583","msg":"看！突然就忙碌起来的样子！我是不是超棒！","msgTime":1621595828716,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"24","ownerName":"SNH48-林思意","totalMsgCount":62101},{"targetName":"您今天进坑了吗🙋","targetAvatar":"/20210505/1620189295380pfi734jw91.jpg","targetType":0,"targetId":"147264238","msg":"拜拜👋溜886～","msgTime":1621584041292,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"874512","ownerName":"SNH48-王秋茹","totalMsgCount":33557},{"targetName":"🍦","targetAvatar":"/20210403/1617433436310xgpf0m8850.jpg","targetType":0,"targetId":"67342180","msg":"💗","msgTime":1621579199258,"icon":["/mediasource/teamLogo/all/gnz_z_log2.png"],"ownerId":"722781","ownerName":"GNZ48-梁乔","totalMsgCount":27928},{"targetName":"娇子铺˙Ⱉ˙","targetAvatar":"/20210425/1619358967437i06nng8jy2.jpg","targetType":0,"targetId":"67284489","msg":"💙","msgTime":1621576958725,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"722780","ownerName":"GNZ48-梁娇","totalMsgCount":26495},{"targetName":"张语格","targetAvatar":"/20201016/1602843642883t3lax5k9hF.jpg","targetType":0,"targetId":"67313770","msg":"[直播消息]","msgTime":1621521002796,"icon":[],"ownerId":"1","ownerName":"张语格","totalMsgCount":3796},{"targetName":"卉卉的房间","targetAvatar":"/20210322/16163906067510mmy54dgfu.jpg","targetType":0,"targetId":"248602943","msg":"变乖了","msgTime":1621447056010,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"42402868","ownerName":"SNH48-陆叶卉","totalMsgCount":5801},{"targetName":"Qw1ko.ꪔ̤̫","targetAvatar":"/20201012/1602514053032N71aYNiA6n.jpg","targetType":0,"targetId":"67303296","msg":"[直播消息]","msgTime":1621089567595,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"530431","ownerName":"GNZ48-陈佳莹","totalMsgCount":9083},{"targetName":"🐷常回家看看","targetAvatar":"/20210427/16194662968127m8jtlkygb.jpg","targetType":0,"targetId":"147269132","msg":"有进展了再告诉大家","msgTime":1621002450016,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"4344250372","ownerName":"SNH48-刘丽千","totalMsgCount":53480},{"targetName":"丝芭江浙沪天花板","targetAvatar":"/20210503/1620041843773mx04j657iv.jpg","targetType":0,"targetId":"261504207","msg":"辛苦了","msgTime":1620487723126,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"45285702","ownerName":"BEJ48-赵嘉丽","totalMsgCount":13778},{"targetName":"灣總的小賣部","targetAvatar":"/20200922/16007481490335LcxUv3LQB.jpg","targetType":0,"targetId":"67352247","msg":"抖音直播","msgTime":1620219519715,"icon":[],"ownerId":"40","ownerName":"邱欣怡","totalMsgCount":88},{"targetName":"新年平安","targetAvatar":"/20200922/160077397014689gc1AvA8z.jpg","targetType":0,"targetId":"67275536","msg":"[直播消息]","msgTime":1619619825041,"icon":["/20200904/15992025288054qD21JfZgU.png"],"ownerId":"623828","ownerName":"BEJ48-李娜","totalMsgCount":32456},{"targetName":"泓哥要努力🎮","targetAvatar":"/mediasource/room/1551355143475XS17mltXoz.jpg","targetType":0,"targetId":"67313801","msg":"午安咯","msgTime":1619334133399,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"407108","ownerName":"IDFT-李泓瑶","totalMsgCount":423},{"targetName":"🌈快乐海🌈","targetAvatar":"/20190824/1566580191535lIvtWMvZbm.jpg","targetType":0,"targetId":"67199656","msg":"都要开开心心的！","msgTime":1618758960328,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"677397","ownerName":"SNH48-李星羽","totalMsgCount":8991},{"targetName":"高崇","targetAvatar":"/mediasource/room/1547909693946xo5MYMq7i6.jpg","targetType":0,"targetId":"67189830","msg":"最近是什么剧一直在提高崇 哈哈哈 有时间得看看了","msgTime":1618440364075,"icon":[],"ownerId":"530385","ownerName":"海外练习生-高崇","totalMsgCount":340},{"targetName":"李倩倩是个爱哭鬼！","targetAvatar":"/20190416/15553898677441T15KB0ebh.jpg","targetType":0,"targetId":"67189874","msg":"晚上好","msgTime":1617012966986,"icon":["/mediasource/teamLogo/fulllogo/snh48_team_yubeisheng.png"],"ownerId":"677398","ownerName":"SNH48-李玉倩","totalMsgCount":8487},{"targetName":"Big Beebee","targetAvatar":"/20190417/155549116897696A11KZZjj.jpg","targetType":0,"targetId":"67333101","msg":"想了很久的话 最后选择离开真的很抱歉 希望你们一切都好 真的 要开心","msgTime":1616596758837,"icon":[],"ownerId":"19","ownerName":"孔肖吟","totalMsgCount":2939},{"targetName":"甜妹","targetAvatar":"/20200822/1598102911491qZPTuB3ur7.jpg","targetType":0,"targetId":"67217598","msg":"突然老了一岁！","msgTime":1616145425164,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"407126","ownerName":"SNH48-杨晔","totalMsgCount":18181},{"targetName":"芳心纵火犯❤️","targetAvatar":"/20210103/1609686428815NI7w3CR969.jpg","targetType":0,"targetId":"67284477","msg":"至少我为我的梦想真的确确实实努力过","msgTime":1615653360288,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"618319","ownerName":"SNH48-程戈","totalMsgCount":25612},{"targetName":"🤖机器人之家🤖","targetAvatar":"/20210201/1612170401637TLzKZ1uiT8.jpg","targetType":0,"targetId":"345764122","msg":"看了个动漫 居然有偷走你的心 笑死","msgTime":1614838232392,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"707374","ownerName":"IDFT-邹冰清","totalMsgCount":687},{"targetName":"小野的彩虹夸夸群🦄","targetAvatar":"/20201113/160526156685478ihl8PZt8.jpg","targetType":0,"targetId":"187441914","msg":"晚安💜","msgTime":1614528060534,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"9276751976","ownerName":"IDFT-余芸萱","totalMsgCount":10944},{"targetName":"我在等风🎐","targetAvatar":"/20200909/1599622880056ntXqeN78o7.jpg","targetType":0,"targetId":"67352359","msg":"[翻牌消息]","msgTime":1606662801284,"icon":["/mediasource/teamLogo2/all/gnz48_g.png"],"ownerId":"707372","ownerName":"GNZ48-徐慧玲","totalMsgCount":12946},{"targetName":"努力🈺️ 不被消灭","targetAvatar":"/20200104/1578149705469cU3sx4m8vY.jpg","targetType":0,"targetId":"67275459","msg":"五周年快乐","msgTime":1606570273915,"icon":["/mediasource/teamLogo2/all/snh48_x.png"],"ownerId":"6735","ownerName":"SNH48-李钊","totalMsgCount":10736},{"targetName":"雪子 上号！","targetAvatar":"/20201106/1604652220333icqtug57L5.jpg","targetType":0,"targetId":"248619104","msg":"我可没有胡说八道喔","msgTime":1606408298688,"icon":["/mediasource/teamLogo2/all/snh48_s2.png"],"ownerId":"42402908","ownerName":"SNH48-刘晨雪","totalMsgCount":988},{"targetName":"毛毛的毛窝","targetAvatar":"/20190415/1555331185712l8afgC3D5z.jpg","targetType":0,"targetId":"67303256","msg":"好暖啊～今天又能开心一整天了","msgTime":1604141705145,"icon":[],"ownerId":"20","ownerName":"李宇琪","totalMsgCount":2393},{"targetName":"民民的房间✨🥳🌙","targetAvatar":"/20200509/1589000681192N230hs6b65.jpg","targetType":0,"targetId":"67265449","msg":"晚安","msgTime":1602348905676,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"417336","ownerName":"IDFT-赵翊民","totalMsgCount":385},{"targetName":"🐙❄️💜⚫️","targetAvatar":"/mediasource/room/1516641910041nlHj87lD24.jpg","targetType":0,"targetId":"67370544","msg":"晚安喔","msgTime":1600524013554,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"407130","ownerName":"IDFT-张韩紫陌","totalMsgCount":485},{"targetName":"生 命 。","targetAvatar":"/20190916/15686409450204PsWCd5058.jpg","targetType":0,"targetId":"67391008","msg":"我🌝","msgTime":1599737085735,"icon":["/mediasource/teamLogo2/all/snh48_h2.png"],"ownerId":"677395","ownerName":"SNH48-陈盼","totalMsgCount":1155},{"targetName":"相亲相爱一家人","targetAvatar":"/20200123/1579756740692TCy9L69jYD.jpg","targetType":0,"targetId":"67313734","msg":"[直播消息]","msgTime":1599229211532,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"286979","ownerName":"IDFT-张嘉予","totalMsgCount":3847},{"targetName":"ZSQ的糖果屋🏡","targetAvatar":"/20200813/15973299095967c40jyO8T8.jpg","targetType":0,"targetId":"67246100","msg":"--------糖糖糖果屋 正式歇业--------","msgTime":1598893730342,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"530383","ownerName":"IDFT-郑诗琪","totalMsgCount":4591},{"targetName":"谢谢大家💖","targetAvatar":"/20200206/15809736285454k7Un354Qj.jpg","targetType":0,"targetId":"67391014","msg":"谢谢大家💖","msgTime":1598888836257,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"707369","ownerName":"IDFT-魏小燕","totalMsgCount":13502},{"targetName":"天降正义","targetAvatar":"/mediasource/room/15338344344399Y4x5sd09w.jpg","targetType":0,"targetId":"67342039","msg":"天 降 正 义——————","msgTime":1598700651292,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"399662","ownerName":"IDFT-江真仪","totalMsgCount":315},{"targetName":"LickDog避难所","targetAvatar":"/20200716/1594886778659K9Y66s7y2r.jpg","targetType":0,"targetId":"67284484","msg":"我还想从我的嘴里亲口说出来呢","msgTime":1597745199079,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"677400","ownerName":"IDFT-王欣颜甜甜","totalMsgCount":3400},{"targetName":"许佳琪","targetAvatar":"/20200115/15790558823956nHFhqN3s5.png","targetType":0,"targetId":"67217577","msg":"还可以投奶票","msgTime":1590792850595,"icon":["/20200603/1591182591234C5oe14AgSR.png"],"ownerId":"21","ownerName":"THE9-许佳琪","totalMsgCount":1729},{"targetName":"🌞","targetAvatar":"/20200417/1587135920788R0wK8PTm2z.jpg","targetType":0,"targetId":"67207870","msg":"晚安啦~","msgTime":1590682918916,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"528336","ownerName":"IDFT-兰昊","totalMsgCount":308},{"targetName":"家里有矿 泉水瓶子","targetAvatar":"/20200313/158402942713801K22t3l4H.jpg","targetType":0,"targetId":"67303313","msg":"晚安！","msgTime":1585068674324,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"614755","ownerName":"IDFT-黄琬璎","totalMsgCount":903},{"targetName":"著名有钱人的房间","targetAvatar":"/20191019/1571419185817LU1hC6N73x.jpg","targetType":0,"targetId":"67303319","msg":"。","msgTime":1579881702048,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"679462","ownerName":"IDFT-李苏洪","totalMsgCount":2920},{"targetName":"🌸紫薇fa的群聊","targetAvatar":"/mediasource/room/1552452801984Ji58kn2d22.jpg","targetType":0,"targetId":"67380647","msg":"","msgTime":0,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"707365","ownerName":"IDFT-戴紫薇","totalMsgCount":0},{"targetName":"佳宁要加油❤","targetAvatar":"/mediasource/room/15534197363994pSBfa86N5.jpg","targetType":0,"targetId":"67342194","msg":"","msgTime":0,"icon":["/mediasource/teamLogo/all/idft_logo_2.png"],"ownerId":"874497","ownerName":"IDFT-卞佳宁","totalMsgCount":0}],"special":[],"ownerHasRoom":false,"ownerHasCreateAuth":false}}')

    db = DBAction('pocket48')
    upd_team_sql = "update member set team=%s, roomid=%s where memberid=%s"
    for user in response["content"]["conversations"]:
        tuan = user['ownerName'].split('-')[0]
        if len(user['icon']) == 0:
            continue
        team = get_team(user['icon'][0])
        rid = user['targetId']
        id = user['ownerId']

        if team == 'ybs':
            if tuan == 'SNH48':
                team = 'SNH预备生'
            elif tuan == 'GNZ48':
                team = 'GNZ预备生'
        db.data_operate(upd_team_sql, (team, rid, id))


if __name__ == '__main__':
    # import_json()
    update_team()
    # 把退役的再变为退役 update pocket48.member set team='退役' where team='0' limit 300
